﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DataSetReservation" targetNamespace="http://tempuri.org/DataSetReservation.xsd" xmlns:mstns="http://tempuri.org/DataSetReservation.xsd" xmlns="http://tempuri.org/DataSetReservation.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="Hotel_SystemConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="Hotel_SystemConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Prototype.Properties.Settings.GlobalReference.Default.Hotel_SystemConnectionString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ReservationTableAdapter" GeneratorDataComponentClassName="ReservationTableAdapter" Name="Reservation" UserDataComponentName="ReservationTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Hotel_SystemConnectionString (Settings)" DbObjectName="[Hotel System].dbo.Reservation" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[Reservation] WHERE (([ReservationID] = @Original_ReservationID) AND ([RoomID] = @Original_RoomID) AND ([ClientID] = @Original_ClientID) AND ([StatusID] = @Original_StatusID) AND ([StartDate] = @Original_StartDate) AND ([EndDate] = @Original_EndDate))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ReservationID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReservationID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RoomID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoomID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ClientID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[Reservation] ([RoomID], [ClientID], [StatusID], [StartDate], [EndDate]) VALUES (@RoomID, @ClientID, @StatusID, @StartDate, @EndDate);
SELECT ReservationID, RoomID, ClientID, StatusID, StartDate, EndDate FROM Reservation WHERE (ReservationID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RoomID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoomID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ClientID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT ReservationID, RoomID, ClientID, StatusID, StartDate, EndDate FROM dbo.Reservation</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[Reservation] SET [RoomID] = @RoomID, [ClientID] = @ClientID, [StatusID] = @StatusID, [StartDate] = @StartDate, [EndDate] = @EndDate WHERE (([ReservationID] = @Original_ReservationID) AND ([RoomID] = @Original_RoomID) AND ([ClientID] = @Original_ClientID) AND ([StatusID] = @Original_StatusID) AND ([StartDate] = @Original_StartDate) AND ([EndDate] = @Original_EndDate));
SELECT ReservationID, RoomID, ClientID, StatusID, StartDate, EndDate FROM Reservation WHERE (ReservationID = @ReservationID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RoomID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoomID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ClientID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ReservationID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReservationID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RoomID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoomID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ClientID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="ReservationID" ColumnName="ReservationID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ReservationID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ReservationID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ReservationID" DataSetColumn="ReservationID" />
              <Mapping SourceColumn="RoomID" DataSetColumn="RoomID" />
              <Mapping SourceColumn="ClientID" DataSetColumn="ClientID" />
              <Mapping SourceColumn="StatusID" DataSetColumn="StatusID" />
              <Mapping SourceColumn="StartDate" DataSetColumn="StartDate" />
              <Mapping SourceColumn="EndDate" DataSetColumn="EndDate" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="Hotel_SystemConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="DeleteReservationByRoomNumber" Modifier="Public" Name="DeleteReservationByRoomNumber" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="DeleteReservationByRoomNumber">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>DELETE FROM Reservation
FROM         Reservation INNER JOIN
                      Rooms ON Reservation.RoomID = Rooms.RoomID
WHERE     (@Number = Rooms.Number)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Number" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="AnsiString" Direction="Input" ParameterName="@Number" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="Hotel_SystemConnectionString (Settings)" DbObjectName="[Hotel System].dbo.Reservation" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByFirstNameLastName" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetDataByFirstNameLastName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByFirstNameLastName" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Reservation.ReservationID, Reservation.RoomID, Reservation.ClientID, Reservation.StatusID, Reservation.StartDate, Reservation.EndDate
FROM         Reservation INNER JOIN
                      Clients ON Reservation.ClientID = Clients.ClientID
WHERE     (@LastName = Clients.LastName) AND (@FirstName = Clients.FirstName)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="LastName" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="AnsiString" Direction="Input" ParameterName="@LastName" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="FirstName" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="AnsiString" Direction="Input" ParameterName="@FirstName" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="Hotel_SystemConnectionString (Settings)" DbObjectName="[Hotel System].dbo.Reservation" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByEGN" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByEGN" GeneratorSourceName="FillByEGN" GetMethodModifier="Public" GetMethodName="GetDataByEGN" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByEGN" UserSourceName="FillByEGN">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Reservation.ReservationID, Reservation.RoomID, Reservation.ClientID, Reservation.StatusID, Reservation.StartDate, Reservation.EndDate
FROM         Reservation INNER JOIN
                      Clients ON Reservation.ClientID = Clients.ClientID
WHERE     (@Egn = Clients.Egn)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Egn" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="AnsiString" Direction="Input" ParameterName="@Egn" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="Hotel_SystemConnectionString (Settings)" DbObjectName="[Hotel System].dbo.Reservation" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByRoomNumber" GeneratorSourceName="FillBy1" GetMethodModifier="Public" GetMethodName="GetDataByRoomNumber" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByRoomNumber" UserSourceName="GetDataByRoomNumber1">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Reservation.ReservationID, Reservation.RoomID, Reservation.ClientID, Reservation.StatusID, Reservation.StartDate, Reservation.EndDate
FROM         Reservation INNER JOIN
                      Rooms ON Reservation.RoomID = Rooms.RoomID
WHERE     (@number = Rooms.Number)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="number" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="AnsiString" Direction="Input" ParameterName="@number" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="Hotel_SystemConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="InsertReservation" Modifier="Public" Name="InsertReservation" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="InsertReservation">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>INSERT INTO [dbo].[Reservation] ([RoomID], [ClientID], [StatusID], [StartDate], [EndDate]) VALUES (@RoomID, @ClientID, @StatusID, @StartDate, @EndDate);
SELECT ReservationID, RoomID, ClientID, StatusID, StartDate, EndDate FROM Reservation WHERE (ReservationID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="RoomID" ColumnName="RoomID" DataSourceName="[Hotel System].dbo.Reservation" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@RoomID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="RoomID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="ClientID" ColumnName="ClientID" DataSourceName="[Hotel System].dbo.Reservation" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ClientID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ClientID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="StatusID" ColumnName="StatusID" DataSourceName="[Hotel System].dbo.Reservation" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@StatusID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="StatusID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="StartDate" ColumnName="StartDate" DataSourceName="[Hotel System].dbo.Reservation" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="StartDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="EndDate" ColumnName="EndDate" DataSourceName="[Hotel System].dbo.Reservation" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="EndDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ReseravtionStatusTableAdapter" GeneratorDataComponentClassName="ReseravtionStatusTableAdapter" Name="ReseravtionStatus" UserDataComponentName="ReseravtionStatusTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Hotel_SystemConnectionString (Settings)" DbObjectName="[Hotel System].dbo.ReseravtionStatus" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[ReseravtionStatus] WHERE (([StatusID] = @Original_StatusID) AND ([Name] = @Original_Name))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[ReseravtionStatus] ([Name]) VALUES (@Name);
SELECT StatusID, Name FROM ReseravtionStatus WHERE (StatusID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT StatusID, Name FROM dbo.ReseravtionStatus</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[ReseravtionStatus] SET [Name] = @Name WHERE (([StatusID] = @Original_StatusID) AND ([Name] = @Original_Name));
SELECT StatusID, Name FROM ReseravtionStatus WHERE (StatusID = @StatusID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="StatusID" ColumnName="StatusID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@StatusID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="StatusID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="StatusID" DataSetColumn="StatusID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="Hotel_SystemConnectionString (Settings)" DbObjectName="[Hotel System].dbo.ReseravtionStatus" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy1" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetStatusIDByName" GeneratorSourceName="FillBy1" GetMethodModifier="Public" GetMethodName="GetStatusIDByName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetStatusIDByName" UserSourceName="FillBy1">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     StatusID AS Expr1, Name AS Expr2, ReseravtionStatus.*
FROM         ReseravtionStatus
WHERE     (Name = @Name)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Name" ColumnName="Name" DataSourceName="[Hotel System].dbo.ReseravtionStatus" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Expr2" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="Hotel_SystemConnectionString (Settings)" DbObjectName="[Hotel System].dbo.ReseravtionStatus" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetReservationStatus" GetMethodModifier="Public" GetMethodName="GetReservationStatus" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetReservationStatus" UserSourceName="GetReservationStatus1">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     ReseravtionStatus.StatusID, ReseravtionStatus.Name
FROM         ReseravtionStatus INNER JOIN
                      Reservation ON ReseravtionStatus.StatusID = Reservation.StatusID</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="Hotel_SystemConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdateReservationStatus" Modifier="Public" Name="UpdateReservationStatus" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="UpdateReservationStatus">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>UPDATE    ReseravtionStatus
SET              Name = @Name
WHERE     (StatusID = @Original_StatusID); 
SELECT StatusID, Name FROM ReseravtionStatus WHERE (StatusID = @StatusID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Name" ColumnName="Name" DataSourceName="[Hotel System].dbo.ReseravtionStatus" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Original_StatusID" ColumnName="StatusID" DataSourceName="[Hotel System].dbo.ReseravtionStatus" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="StatusID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="StatusID" ColumnName="StatusID" DataSourceName="[Hotel System].dbo.ReseravtionStatus" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@StatusID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="StatusID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClientsTableAdapter" GeneratorDataComponentClassName="ClientsTableAdapter" Name="Clients" UserDataComponentName="ClientsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Hotel_SystemConnectionString (Settings)" DbObjectName="[Hotel System].dbo.Clients" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[Clients] WHERE (([ClientID] = @Original_ClientID) AND ([FirstName] = @Original_FirstName) AND ((@IsNull_MiddleName = 1 AND [MiddleName] IS NULL) OR ([MiddleName] = @Original_MiddleName)) AND ([LastName] = @Original_LastName) AND ([Phone] = @Original_Phone) AND ([Egn] = @Original_Egn))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ClientID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MiddleName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MiddleName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MiddleName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Egn" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Egn" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[Clients] ([FirstName], [MiddleName], [LastName], [Phone], [Egn]) VALUES (@FirstName, @MiddleName, @LastName, @Phone, @Egn);
SELECT ClientID, FirstName, MiddleName, LastName, Phone, Egn FROM Clients WHERE (ClientID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MiddleName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Egn" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Egn" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT ClientID, FirstName, MiddleName, LastName, Phone, Egn FROM dbo.Clients</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[Clients] SET [FirstName] = @FirstName, [MiddleName] = @MiddleName, [LastName] = @LastName, [Phone] = @Phone, [Egn] = @Egn WHERE (([ClientID] = @Original_ClientID) AND ([FirstName] = @Original_FirstName) AND ((@IsNull_MiddleName = 1 AND [MiddleName] IS NULL) OR ([MiddleName] = @Original_MiddleName)) AND ([LastName] = @Original_LastName) AND ([Phone] = @Original_Phone) AND ([Egn] = @Original_Egn));
SELECT ClientID, FirstName, MiddleName, LastName, Phone, Egn FROM Clients WHERE (ClientID = @ClientID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MiddleName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Egn" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Egn" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ClientID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MiddleName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MiddleName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MiddleName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Egn" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Egn" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="ClientID" ColumnName="ClientID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ClientID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ClientID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ClientID" DataSetColumn="ClientID" />
              <Mapping SourceColumn="FirstName" DataSetColumn="FirstName" />
              <Mapping SourceColumn="MiddleName" DataSetColumn="MiddleName" />
              <Mapping SourceColumn="LastName" DataSetColumn="LastName" />
              <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
              <Mapping SourceColumn="Egn" DataSetColumn="Egn" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="Hotel_SystemConnectionString (Settings)" DbObjectName="[Hotel System].dbo.Clients" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByEGN" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByEGN" GeneratorSourceName="FillByEGN" GetMethodModifier="Public" GetMethodName="GetDataByEGN" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByEGN" UserSourceName="FillByEGN">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     ClientID, FirstName, MiddleName, LastName, Phone, Egn
FROM         Clients
WHERE     (@Egn = Egn)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Egn" ColumnName="Egn" DataSourceName="[Hotel System].dbo.Clients" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@Egn" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="Egn" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="Hotel_SystemConnectionString (Settings)" DbObjectName="[Hotel System].dbo.Clients" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetClients" GetMethodModifier="Public" GetMethodName="GetClients" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetClients" UserSourceName="GetClients1">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Clients.ClientID, Clients.FirstName, Clients.MiddleName, Clients.LastName, Clients.Phone, Clients.Egn
FROM         Clients INNER JOIN
                      Reservation ON Clients.ClientID = Reservation.ClientID</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="Hotel_SystemConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="InsertClients" Modifier="Public" Name="InsertClients" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="InsertClients">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>INSERT INTO Clients
                      (FirstName, LastName, Phone, Egn)
VALUES     (@FirstName,@LastName,@Phone,@Egn);  
SELECT ClientID, FirstName, MiddleName, LastName, Phone, Egn FROM Clients WHERE (ClientID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="FirstName" ColumnName="FirstName" DataSourceName="[Hotel System].dbo.Clients" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@FirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="FirstName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="LastName" ColumnName="LastName" DataSourceName="[Hotel System].dbo.Clients" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@LastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="LastName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Phone" ColumnName="Phone" DataSourceName="[Hotel System].dbo.Clients" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Phone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Egn" ColumnName="Egn" DataSourceName="[Hotel System].dbo.Clients" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@Egn" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="Egn" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RoomsTableAdapter" GeneratorDataComponentClassName="RoomsTableAdapter" Name="Rooms" UserDataComponentName="RoomsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Hotel_SystemConnectionString (Settings)" DbObjectName="[Hotel System].dbo.Rooms" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[Rooms] WHERE (([RoomID] = @Original_RoomID) AND ([Number] = @Original_Number) AND ([Prise] = @Original_Prise) AND ([RoomTypeID] = @Original_RoomTypeID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RoomID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoomID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Number" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Number" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Prise" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Prise" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RoomTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoomTypeID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[Rooms] ([Number], [Prise], [RoomTypeID]) VALUES (@Number, @Prise, @RoomTypeID);
SELECT RoomID, Number, Prise, RoomTypeID FROM Rooms WHERE (RoomID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Number" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Number" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Prise" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Prise" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RoomTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoomTypeID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT RoomID, Number, Prise, RoomTypeID FROM dbo.Rooms</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[Rooms] SET [Number] = @Number, [Prise] = @Prise, [RoomTypeID] = @RoomTypeID WHERE (([RoomID] = @Original_RoomID) AND ([Number] = @Original_Number) AND ([Prise] = @Original_Prise) AND ([RoomTypeID] = @Original_RoomTypeID));
SELECT RoomID, Number, Prise, RoomTypeID FROM Rooms WHERE (RoomID = @RoomID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Number" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Number" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Prise" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Prise" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RoomTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoomTypeID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RoomID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoomID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Number" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Number" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Prise" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Prise" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RoomTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoomTypeID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="RoomID" ColumnName="RoomID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@RoomID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="RoomID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="RoomID" DataSetColumn="RoomID" />
              <Mapping SourceColumn="Number" DataSetColumn="Number" />
              <Mapping SourceColumn="Prise" DataSetColumn="Prise" />
              <Mapping SourceColumn="RoomTypeID" DataSetColumn="RoomTypeID" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="Hotel_SystemConnectionString (Settings)" DbObjectName="[Hotel System].dbo.Rooms" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy1" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetRoomIDByName" GeneratorSourceName="FillBy1" GetMethodModifier="Public" GetMethodName="GetRoomIDByName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetRoomIDByName" UserSourceName="FillBy1">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Rooms.*
FROM         Rooms
WHERE     (Number = @Number)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Number" ColumnName="Number" DataSourceName="[Hotel System].dbo.Rooms" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@Number" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="Number" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="Hotel_SystemConnectionString (Settings)" DbObjectName="[Hotel System].dbo.Rooms" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetRooms" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetRooms" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetRooms" UserSourceName="GetRooms1">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Rooms.RoomID, Rooms.Number, Rooms.Prise, Rooms.RoomTypeID
FROM         Rooms INNER JOIN
                      Reservation ON Rooms.RoomID = Reservation.RoomID</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DataSetReservation" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DataSetReservation" msprop:Generator_DataSetName="DataSetReservation">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Reservation" msprop:Generator_UserTableName="Reservation" msprop:Generator_RowDeletedName="ReservationRowDeleted" msprop:Generator_RowChangedName="ReservationRowChanged" msprop:Generator_RowClassName="ReservationRow" msprop:Generator_RowChangingName="ReservationRowChanging" msprop:Generator_RowEvArgName="ReservationRowChangeEvent" msprop:Generator_RowEvHandlerName="ReservationRowChangeEventHandler" msprop:Generator_TableClassName="ReservationDataTable" msprop:Generator_TableVarName="tableReservation" msprop:Generator_RowDeletingName="ReservationRowDeleting" msprop:Generator_TablePropName="Reservation">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ReservationID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="ReservationID" msprop:Generator_ColumnPropNameInRow="ReservationID" msprop:Generator_ColumnVarNameInTable="columnReservationID" msprop:Generator_ColumnPropNameInTable="ReservationIDColumn" type="xs:int" />
              <xs:element name="RoomID" msprop:Generator_UserColumnName="RoomID" msprop:Generator_ColumnPropNameInRow="RoomID" msprop:Generator_ColumnVarNameInTable="columnRoomID" msprop:Generator_ColumnPropNameInTable="RoomIDColumn" type="xs:int" />
              <xs:element name="ClientID" msprop:Generator_UserColumnName="ClientID" msprop:Generator_ColumnPropNameInRow="ClientID" msprop:Generator_ColumnVarNameInTable="columnClientID" msprop:Generator_ColumnPropNameInTable="ClientIDColumn" type="xs:int" />
              <xs:element name="StatusID" msprop:Generator_UserColumnName="StatusID" msprop:Generator_ColumnPropNameInRow="StatusID" msprop:Generator_ColumnVarNameInTable="columnStatusID" msprop:Generator_ColumnPropNameInTable="StatusIDColumn" type="xs:int" />
              <xs:element name="StartDate" msprop:Generator_UserColumnName="StartDate" msprop:Generator_ColumnPropNameInRow="StartDate" msprop:Generator_ColumnVarNameInTable="columnStartDate" msprop:Generator_ColumnPropNameInTable="StartDateColumn" type="xs:dateTime" />
              <xs:element name="EndDate" msprop:Generator_UserColumnName="EndDate" msprop:Generator_ColumnPropNameInRow="EndDate" msprop:Generator_ColumnVarNameInTable="columnEndDate" msprop:Generator_ColumnPropNameInTable="EndDateColumn" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ReseravtionStatus" msprop:Generator_UserTableName="ReseravtionStatus" msprop:Generator_RowDeletedName="ReseravtionStatusRowDeleted" msprop:Generator_RowChangedName="ReseravtionStatusRowChanged" msprop:Generator_RowClassName="ReseravtionStatusRow" msprop:Generator_RowChangingName="ReseravtionStatusRowChanging" msprop:Generator_RowEvArgName="ReseravtionStatusRowChangeEvent" msprop:Generator_RowEvHandlerName="ReseravtionStatusRowChangeEventHandler" msprop:Generator_TableClassName="ReseravtionStatusDataTable" msprop:Generator_TableVarName="tableReseravtionStatus" msprop:Generator_RowDeletingName="ReseravtionStatusRowDeleting" msprop:Generator_TablePropName="ReseravtionStatus">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="StatusID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="StatusID" msprop:Generator_ColumnPropNameInRow="StatusID" msprop:Generator_ColumnVarNameInTable="columnStatusID" msprop:Generator_ColumnPropNameInTable="StatusIDColumn" type="xs:int" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Clients" msprop:Generator_UserTableName="Clients" msprop:Generator_RowDeletedName="ClientsRowDeleted" msprop:Generator_RowChangedName="ClientsRowChanged" msprop:Generator_RowClassName="ClientsRow" msprop:Generator_RowChangingName="ClientsRowChanging" msprop:Generator_RowEvArgName="ClientsRowChangeEvent" msprop:Generator_RowEvHandlerName="ClientsRowChangeEventHandler" msprop:Generator_TableClassName="ClientsDataTable" msprop:Generator_TableVarName="tableClients" msprop:Generator_RowDeletingName="ClientsRowDeleting" msprop:Generator_TablePropName="Clients">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ClientID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="ClientID" msprop:Generator_ColumnPropNameInRow="ClientID" msprop:Generator_ColumnVarNameInTable="columnClientID" msprop:Generator_ColumnPropNameInTable="ClientIDColumn" type="xs:int" />
              <xs:element name="FirstName" msprop:Generator_UserColumnName="FirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MiddleName" msprop:Generator_UserColumnName="MiddleName" msprop:Generator_ColumnPropNameInRow="MiddleName" msprop:Generator_ColumnVarNameInTable="columnMiddleName" msprop:Generator_ColumnPropNameInTable="MiddleNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastName" msprop:Generator_UserColumnName="LastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Phone" msprop:Generator_UserColumnName="Phone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_ColumnPropNameInTable="PhoneColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Egn" msprop:Generator_UserColumnName="Egn" msprop:Generator_ColumnPropNameInRow="Egn" msprop:Generator_ColumnVarNameInTable="columnEgn" msprop:Generator_ColumnPropNameInTable="EgnColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Rooms" msprop:Generator_UserTableName="Rooms" msprop:Generator_RowDeletedName="RoomsRowDeleted" msprop:Generator_RowChangedName="RoomsRowChanged" msprop:Generator_RowClassName="RoomsRow" msprop:Generator_RowChangingName="RoomsRowChanging" msprop:Generator_RowEvArgName="RoomsRowChangeEvent" msprop:Generator_RowEvHandlerName="RoomsRowChangeEventHandler" msprop:Generator_TableClassName="RoomsDataTable" msprop:Generator_TableVarName="tableRooms" msprop:Generator_RowDeletingName="RoomsRowDeleting" msprop:Generator_TablePropName="Rooms">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="RoomID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="RoomID" msprop:Generator_ColumnPropNameInRow="RoomID" msprop:Generator_ColumnVarNameInTable="columnRoomID" msprop:Generator_ColumnPropNameInTable="RoomIDColumn" type="xs:int" />
              <xs:element name="Number" msprop:Generator_UserColumnName="Number" msprop:Generator_ColumnPropNameInRow="Number" msprop:Generator_ColumnVarNameInTable="columnNumber" msprop:Generator_ColumnPropNameInTable="NumberColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Prise" msprop:Generator_UserColumnName="Prise" msprop:Generator_ColumnPropNameInRow="Prise" msprop:Generator_ColumnVarNameInTable="columnPrise" msprop:Generator_ColumnPropNameInTable="PriseColumn" type="xs:decimal" />
              <xs:element name="RoomTypeID" msprop:Generator_UserColumnName="RoomTypeID" msprop:Generator_ColumnPropNameInRow="RoomTypeID" msprop:Generator_ColumnVarNameInTable="columnRoomTypeID" msprop:Generator_ColumnPropNameInTable="RoomTypeIDColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Reservation" />
      <xs:field xpath="mstns:ReservationID" />
    </xs:unique>
    <xs:unique name="ReseravtionStatus_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ReseravtionStatus" />
      <xs:field xpath="mstns:StatusID" />
    </xs:unique>
    <xs:unique name="Clients_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Clients" />
      <xs:field xpath="mstns:ClientID" />
    </xs:unique>
    <xs:unique name="Rooms_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Rooms" />
      <xs:field xpath="mstns:RoomID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Reservation_ReseravtionStatus" msdata:parent="ReseravtionStatus" msdata:child="Reservation" msdata:parentkey="StatusID" msdata:childkey="StatusID" msprop:Generator_UserRelationName="FK_Reservation_ReseravtionStatus" msprop:Generator_RelationVarName="relationFK_Reservation_ReseravtionStatus" msprop:Generator_UserChildTable="Reservation" msprop:Generator_UserParentTable="ReseravtionStatus" msprop:Generator_ParentPropName="ReseravtionStatusRow" msprop:Generator_ChildPropName="GetReservationRows" />
      <msdata:Relationship name="FK_Reservation_Clients" msdata:parent="Clients" msdata:child="Reservation" msdata:parentkey="ClientID" msdata:childkey="ClientID" msprop:Generator_UserRelationName="FK_Reservation_Clients" msprop:Generator_RelationVarName="relationFK_Reservation_Clients" msprop:Generator_UserChildTable="Reservation" msprop:Generator_UserParentTable="Clients" msprop:Generator_ParentPropName="ClientsRow" msprop:Generator_ChildPropName="GetReservationRows" />
      <msdata:Relationship name="FK_Reservation_Rooms" msdata:parent="Rooms" msdata:child="Reservation" msdata:parentkey="RoomID" msdata:childkey="RoomID" msprop:Generator_UserRelationName="FK_Reservation_Rooms" msprop:Generator_RelationVarName="relationFK_Reservation_Rooms" msprop:Generator_UserChildTable="Reservation" msprop:Generator_UserParentTable="Rooms" msprop:Generator_ParentPropName="RoomsRow" msprop:Generator_ChildPropName="GetReservationRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>